
--风险等级
DELETE FROM STTC_DATADICT WHERE CLSNO = 'TYZJ_FXDJ';
DELETE FROM STTC_DATALIST WHERE CLSNO = 'TYZJ_FXDJ';

INSERT INTO STTC_DATALIST (CLSNO, CLSNAME, FLAG, TBLNAME, MNTFLAG, LSTMNTDATE, LSTMNTUSER, EFFECTFLAG)
VALUES ('TYZJ_FXDJ', '风险等级', 'STTC_DATA', NULL, 'N', '2017-02-13', NULL, 'E');

INSERT INTO STTC_DATADICT (CLSNO, ITEMCODE, ORDERNO, CNNAME, ENNAME, REMARK, MNTFLAG, CREATEDATE, CREATEUSER, LSTMNTDATE, LSTMNTUSER, EFFECTFLAG, DEFAULTVALUE)
VALUES ('TYZJ_FXDJ', '1', 1, '高风险', NULL, NULL, 'Y', '2017-02-13', NULL, '2017-02-13', NULL, 'E', NULL);

INSERT INTO STTC_DATADICT (CLSNO, ITEMCODE, ORDERNO, CNNAME, ENNAME, REMARK, MNTFLAG, CREATEDATE, CREATEUSER, LSTMNTDATE, LSTMNTUSER, EFFECTFLAG, DEFAULTVALUE)
VALUES ('TYZJ_FXDJ', '2', 2, '较高风险', NULL, NULL, 'Y', '2017-02-13', NULL, '2017-02-13', NULL, 'E', NULL);

INSERT INTO STTC_DATADICT (CLSNO, ITEMCODE, ORDERNO, CNNAME, ENNAME, REMARK, MNTFLAG, CREATEDATE, CREATEUSER, LSTMNTDATE, LSTMNTUSER, EFFECTFLAG, DEFAULTVALUE)
VALUES ('TYZJ_FXDJ', '3', 3, '中等风险', NULL, NULL, 'Y', '2017-02-13', NULL, '2017-02-13', NULL, 'E', NULL);

INSERT INTO STTC_DATADICT (CLSNO, ITEMCODE, ORDERNO, CNNAME, ENNAME, REMARK, MNTFLAG, CREATEDATE, CREATEUSER, LSTMNTDATE, LSTMNTUSER, EFFECTFLAG, DEFAULTVALUE)
VALUES ('TYZJ_FXDJ', '4', 4, '低风险', NULL, NULL, 'Y', '2017-02-13', NULL, '2017-02-13', NULL, 'E', NULL);

INSERT INTO STTC_DATADICT (CLSNO, ITEMCODE, ORDERNO, CNNAME, ENNAME, REMARK, MNTFLAG, CREATEDATE, CREATEUSER, LSTMNTDATE, LSTMNTUSER, EFFECTFLAG, DEFAULTVALUE)
VALUES ('TYZJ_FXDJ', '5', 5, '极低风险', NULL, NULL, 'Y', '2017-02-13', NULL, '2017-02-13', NULL, 'E', NULL);

